Execute as
Specify the security context under which the trigger is executed.
Note: Support from SQL Server 2005 or later and SQL Azure.
Options
Note: SQL Azure does not support.
Encrypted
Obfuscate the text of the CREATE TRIGGER statement.Note: Support from SQL Server 2005 or later.
Not for replication
Indicate that the trigger should not be executed when a replication agent modifies the table that is involved in the trigger.
Append
Specify that an additional trigger of an existing type should be added.